package util;

import com.google.common.collect.Lists;

import java.util.List;

/**
 * Created by shangdong on 17/5/30.
 */
public class MyTestUtils {

//   public static List<Integer> list = Lists.newArrayList(8803,8804,8805,8806,8808,8820,8821,8822,8823,8824,8825,8826,8827,8828,8829,8830);

    public static List<Integer> list = Lists.newArrayList(3373,3374,3377,3378,3379,8801);

    public static void main(String[] args) {
        String a = "INSERT INTO `t_goods` (`goods_id`, `category_id`, `goods_name`, `nickname`, `image`, `del_state`, `simple_describe`, `detail_describe`, `is_marketable`, `recommend`, `create_time`, `update_time`, `admin_id`, `image_detail`, `sdk_info`)\n" +
                "VALUES";
        StringBuilder sb = new StringBuilder(a);

        for (Integer i : list) {
            String s = i.toString();
            String b = "("+s+", 65, '"+s+"', '眼镜', '/static/glassinfo/"+s+"/icon.jpg', 1, '眼镜', '<p><img src=\\\"http://www.wanjinbaoglasses.com/static/ueditor/upload1/20160502/14621703516653.jpg\\\" width=\\\"100%\\\" /></p>', 1, 2, '2017-05-13 20:49:55', '2017-05-13 20:49:55', 2, '/static/glassinfo/"+s+"/detail1.jpg,/static/glassinfo/"+s+"/detail2.jpg,/static/glassinfo/"+s+"/detail3.jpg,/static/glassinfo/"+s+"/detail4.jpg', ''),";
//            String format = String.format(b, s, s, s, s, s, s, s);
            sb.append(b);
            sb.append("\n");
        }

        System.out.println(sb.toString());

    }
}
